var express = require('express');
var router = express.Router();
var connection = require('../db/sql.js')
var user = require('../db/userSql.js')
var QcloudSms = require("qcloudsms_js");
let jwt = require('jsonwebtoken')
//引入支付宝配置文件
const alipaySdk = require('../db/alipay.js');
const AlipayFormData = require('alipay-sdk/lib/form').default;
//引入axiso
const axios = require('axios');

/* GET home page. */
router.get('/', function (req, res, next) {
  res.render('index', { title: 'Express' });
});

// token过期时间
function getTimeToken(exp) {
  let getTime = parseInt(new Date().getTime() / 1000)
  if (getTime - exp > 60) {
    return true
  }
}



//支付状态
router.post('/api/successPayment', function (req, res, next) {
  //token
  let token = req.headers.token;
  let tokenObj = jwt.decode(token);
  //订单号
  let out_trade_no = req.body.out_trade_no;
  let trade_no = req.body.trade_no;
  //支付宝配置
  const formData = new AlipayFormData();
  // 调用 setMethod 并传入 get，会返回可以跳转到支付页面的 url
  formData.setMethod('get');
  //支付时信息
  formData.addField('bizContent', {
    out_trade_no,
    trade_no
  });
  //返回promise
  const result = alipaySdk.exec(
    'alipay.trade.query',
    {},
    { formData: formData },
  );
  //后端请求支付宝
  result.then(resData => {
    axios({
      method: 'GET',
      url: resData
    }).then(data => {
      let responseCode = data.data.alipay_trade_query_response;
      if (responseCode.code == '10000') {
        switch (responseCode.trade_status) {
          case 'WAIT_BUYER_PAY':
            res.send({
              data: {
                code: 0,
                data: {
                  msg: '支付宝有交易记录，没付款'
                }
              }
            })
            break;

          case 'TRADE_CLOSED':
            res.send({
              data: {
                code: 1,
                data: {
                  msg: '交易关闭'
                }
              }
            })
            break;

          case 'TRADE_FINISHED':
            connection.query(`select * from user where tel = ${tokenObj.tel}`, function (error, results) {
              //用户id
              let uId = results[0].id;
              connection.query(`select * from store_order where uId = ${uId} and order_id = ${out_trade_no}`, function (err, result) {
                let id = result[0].id;
                //订单的状态修改掉2==》3
                connection.query(`update store_order set order_status = replace(order_status,'2','3') where id = ${id}`, function () {
                  res.send({
                    data: {
                      code: 2,
                      data: {
                        msg: '交易完成'
                      }
                    }
                  })
                })
              })
            })
            break;

          case 'TRADE_SUCCESS':
            connection.query(`select * from user where tel = ${tokenObj.tel}`, function (error, results) {
              //用户id
              let uId = results[0].id;
              connection.query(`select * from store_order where uId = ${uId} and order_id = ${out_trade_no}`, function (err, result) {
                let id = result[0].id;
                //订单的状态修改掉2==》3
                connection.query(`update store_order set order_status = replace(order_status,'2','3') where id = ${id}`, function () {
                  res.send({
                    data: {
                      code: 2,
                      data: {
                        msg: '交易完成'
                      }
                    }
                  })
                })
              })
            })
            break;
        }
      } else if (responseCode.code == '40004') {
        res.send({
          data: {
            code: 4,
            msg: '交易不存在'
          }
        })
      }
    }).catch(err => {
      res.send({
        data: {
          code: 500,
          msg: '交易失败',
          err
        }
      })
    })
  })
})


//发起支付
router.post('/api/payment', function (req, res, next) {

  //订单号
  let orderId = req.body.orderId;
  //商品总价
  let price = req.body.price;
  //购买商品的名称
  let name = req.body.name;
  //开始对接支付宝API
  const formData = new AlipayFormData();
  // 调用 setMethod 并传入 get，会返回可以跳转到支付页面的 url
  formData.setMethod('get');
  //支付时信息
  formData.addField('bizContent', {
    outTradeNo: orderId,//订单号
    productCode: 'FAST_INSTANT_TRADE_PAY',//写死的
    totalAmount: price,//价格
    subject: name,//商品名称
  });
  //支付成功或者失败跳转的链接
  formData.addField('returnUrl', 'http://localhost:8080/#/payment');
  //返回promise
  const result = alipaySdk.exec(
    'alipay.trade.page.pay',
    {},
    { formData: formData },
  );
  //对接支付宝成功，支付宝方返回的数据
  result.then(resp => {
    res.send({
      data: {
        code: 200,
        success: true,
        msg: '支付中',
        paymentUrl: resp
      }
    })

  })
  return
})

//修改订单状态
router.post('/api/submitOrder', function (req, res, next) {
  //token
  let token = req.headers.token;
  let tokenObj = jwt.decode(token);
  //订单号
  let orderId = req.body.orderId;
  //购物车选中的商品id
  let shopArr = req.body.shopArr;


  //查询用户
  connection.query(`select * from user where tel = ${tokenObj.tel}`, function (error, results) {
    //用户id
    let uId = results[0].id;

    connection.query(`select * from store_order where uId = ${uId} and order_id = ${orderId}`, function (err, result) {
      //订单的数据库id
      let id = result[0].id;


      //修改订单状态 1==>2
      connection.query(`update store_order set order_status = replace(order_status,'1','2') where id = ${id}`, function (e, r) {
        //购物车数据删除
        shopArr.forEach(v => {

          connection.query(`delete from goods_cart where id = ${v.id}`, function () {

          })
        })
        res.send({
          data: {
            code: 200,
            success: true
          }
        })
      })
    })
  })

})

//生成一个订单
router.post('/api/addOrder', function (req, res, next) {
  //token
  let token = req.headers.token;
  let tokenObj = jwt.decode(token);
  //前端给后端的数据
  let goodsArr = req.body.arr;
  //生成订单号order_id，规则：时间戳 + 6为随机数
  function setTimeDateFmt(s) {
    return s < 10 ? '0' + s : s
  }
  function randomNumber() {
    const now = new Date();
    let month = now.getMonth() + 1;
    let day = now.getDate();
    let hour = now.getHours();
    let minutes = now.getMinutes();
    let seconds = now.getSeconds();
    month = setTimeDateFmt(month);
    day = setTimeDateFmt(day);
    hour = setTimeDateFmt(hour);
    minutes = setTimeDateFmt(minutes);
    seconds = setTimeDateFmt(seconds);
    let orderCode = now.getFullYear().toString() + month.toString() + day + hour + minutes + seconds + (Math.round(Math.random() * 1000000)).toString();
    return orderCode;
  }
  /*
  未支付：1
  待支付：2
  支付成功：3
  支付失败：4 | 0
  */
  //商品列表名称
  let goodsName = [];
  //订单商品总金额
  let goodsPrice = 0;
  //订单商品总数量
  let goodsNum = 0;
  //订单号
  let orderId = randomNumber();

  goodsArr.forEach(v => {
    goodsName.push(v.goods_name);
    goodsPrice += v.goods_price * v.goods_num;
    goodsNum += parseInt(v.goods_num);
  })
  //查询当前用户
  connection.query(`select * from user where tel = ${tokenObj.tel}`, function (error, results) {
    //用户id
    let uId = results[0].id;
    console.log(orderId);

    connection.query(`insert into store_order (order_id,goods_name,goods_price,goods_num,order_status,uId) values ('${orderId}','${goodsName}','${goodsPrice}','${goodsNum}','1',${uId})`, function () {
      connection.query(`select * from store_order where uId = ${uId} and order_id='${orderId}'`, function (err, result) {
        res.send({
          data: {
            success: true,
            code: 200,
            data: result
          }
        })

      })
    })
  })

})

//删除收货地址
router.post('/api/deleteAddress', function (req, res, next) {
  let id = req.body.id;
  connection.query(`delete from address where id = ${id}`, function (error, results) {
    res.send({
      data: {
        code: 200,
        success: true,
        msg: '删除成功'
      }
    })
  })
})
//修改收货地址
router.post('/api/updateAddress', function (req, res, next) {
  console.log(req.body);
  //token
  let token = req.headers.token;
  let tokenObj = jwt.decode(token);
  //拿到前端给后端传入的数据
  let body = req.body;
  let [id, name, tel, province, city, county, addressDetail, isDefault, areaCode] = [
    body.id,
    body.name,
    body.tel,
    body.province,
    body.city,
    body.county,
    body.addressDetail,
    body.isDefault,
    body.areaCode
  ];
  //查询用户
  connection.query(`select * from user where tel = ${tokenObj.tel}`, function (error, results) {
    //用户id
    let uId = results[0].id;
    //对应查询到0 或者 1 有没有默认收货地址
    connection.query(`select * from address where uId = ${uId} and isDefault = ${isDefault}`, function (err, result) {
      if (result.length > 0) {
        let addressId = result[0].id;
        connection.query(`update address isDefault = replace(isDefault,'1','0') where id = ${addressId}`, function (e, r) {
          let updateSql = `update address set uId = ? , name = ? , tel = ? , province = ? , city = ? ,county = ? , addressDetail = ? , isDefault = ? , areaCode = ? where id = ${id}`;
          connection.query(updateSql, [uId, name, tel, province, city, county, addressDetail, isDefault, areaCode], function (errors, datas) {
            res.send({
              data: {
                code: 200,
                success: true,
                msg: '修改成功'
              }
            })
          })
        })
      } else {
        let updateSql = `update address set uId = ? , name = ? , tel = ? , province = ? , city = ? ,county = ? , addressDetail = ? , isDefault = ? , areaCode = ? where id = ${id}`;
        connection.query(updateSql, [uId, name, tel, province, city, county, addressDetail, isDefault, areaCode], function (errors, datas) {
          res.send({
            data: {
              code: 200,
              success: true,
              msg: '修改成功'
            }
          })
        })
      }
    })
  })
})

//查询收货地址
router.post('/api/selectAddress', function (req, res, next) {
  //token
  let token = req.headers.token;
  let tokenObj = jwt.decode(token);

  //查询用户
  connection.query(`select * from user where tel = ${tokenObj.tel}`, function (error, results) {
    //用户id
    let uId = results[0].id;
    connection.query(`select * from address where uId = ${uId}`, function (err, result) {
      res.send({
        data: {
          code: 200,
          success: true,
          msg: '查询成功',
          data: result
        }
      })
    })
  })
})

// 新增收货地址
router.post('/api/addAddress', function (req, res, next) {
  //token
  let token = req.headers.token;
  let tokenObj = jwt.decode(token);
  //拿到前端给后端传入的数据
  let body = req.body;
  let { name, tel, province, city, county, addressDetail, isDefault, areaCode } = body


  // //查询用户
  connection.query(`select * from user where tel = ${tokenObj.tel}`, function (error, results) {
    //用户id
    let uId = results[0].id;
    //增加一条收货地址

    if (isDefault != 1) {
      connection.query(`insert into address (uId,name,tel,province,city,county,addressDetail,isDefault,areaCode) values (${uId},"${name}","${tel}","${province}","${city}","${county}","${addressDetail}","${isDefault}","${areaCode}")`, function (err, result) {
        res.send({
          data: {
            code: 200,
            success: true,
            msg: '收货地址添加成功'
          }
        })
      })
    } else {

      connection.query(`select * from address where uId = ${uId} and isDefault = ${isDefault}`, function (err, result) {
        if (result.length > 0) {
          let addressId = result[0].id;
          connection.query(`update address set isDefault = replace(isDefault,'1','0') where id = ${addressId}`, function () {
            connection.query(`insert into address (uId,name,tel,province,city,county,addressDetail,isDefault,areaCode) values (${uId},"${name}","${tel}","${province}","${city}","${county}","${addressDetail}","${isDefault}","${areaCode}")`, function (e, r) {
              res.send({
                data: {
                  code: 200,
                  success: true,
                  msg: '收货地址添加成功'
                }
              })
            })
          })
        } else {
          connection.query(`insert into address (uId,name,tel,province,city,county,addressDetail,isDefault,areaCode) values (${uId},"${name}","${tel}","${province}","${city}","${county}","${addressDetail}","${isDefault}","${areaCode}")`, function (err, result) {
            res.send({
              data: {
                code: 200,
                success: true,
                msg: '收货地址添加成功'
              }
            })
          })
        }
      })

    }
  })
})


//修改购物车商品数量
router.post('/api/updateNum', function (req, res, next) {
  let { num, id } = req.body

  connection.query(`select * from goods_cart where id=${id}`, function (e, r) {
    // 原来的数量
    let num2 = r[0].goods_num
    connection.query(`update goods_cart set goods_num=replace(goods_num,${num2},${num}) where id=${id}`, function (err, results) {
      res.send({
        data: {
          code: 200,
          success: true,
          msg: '修改成功'
        }
      })
    })

  })

})


//删除购物车数据
router.post('/api/delCart', function (req, res, next) {
  let id = req.body.goodsId
  connection.query(`delete from goods_cart where id=${id} `, function (err, results) {
    res.send({
      data: {
        code: 200,
        success: true,
        msg: '删除成功'
      }
    })
  })

})

// 查询购物车数据
router.post('/api/getCartData', function (req, res, next) {
  let token = req.headers.token
  //  解析token
  let tokenObj = jwt.decode(token)

  //  查询用户
  connection.query(`select * from user where tel=${tokenObj.tel}`, function (err, results) {
    //  用户id
    let uId = results[0].id


    // // 查询购物che
    connection.query(`select * from goods_cart where uId =${uId}`, function (e, r) {

      res.send({
        data: {
          code: 200,
          success: true,
          data: r
        }
      })
    })

  })

})

// 加入购物车
router.post('/api/addcart', function (req, res, next) {

  // 后端接受前端的参数
  let goodsId = req.body.goodsId

  let token = req.headers.token
  //  解析token
  let tokenObj = jwt.decode(token)


  //如果执行，就证明token过期了
  // if (getTimeToken(tokenObj.exp)) {
  //   res.send({
  //     data: {
  //       code: 1000
  //     }
  //   })
  // }

  //  查询用户
  connection.query(`select * from user where tel=${tokenObj.tel}`, function (err, results) {
    //  用户id
    let uId = results[0].id
    // 查询商品
    connection.query(`select * from goodslist where id=${goodsId}`, function (err, results) {
      let goodsName = results[0].name
      let price = results[0].price
      let imgUrl = results[0].imgUrl



      // 当前用户当前是否添加过本商品
      connection.query(`select * from goods_cart where uId=${uId} and goods_id=${goodsId}`, function (e, r) {

        // 证明用户之前是有该商品
        if (r.length > 0) {
          let num = r[0].goods_num
          connection.query(`update goods_cart set goods_num=replace(goods_num,${num},${parseInt(num) + 1}) where id =${r[0].id}`, function () {
            res.send({
              code: 200,
              success: true,
              msg: '添加成功'
            })
          })
        } else {
          connection.query(`insert into goods_cart(uId,goods_id,goods_name,goods_price,goods_num,goods_imgUrl) values ("${uId}","${goodsId}","${goodsName}","${price}","1","${imgUrl}")`, function (e, r) {
            res.send({
              code: 200,
              success: true,
              msg: '添加成功'
            })
          })



        }


      })


    })
  })


})

// 修改密码
router.post('/api/modifyPassWord', function (req, res, next) {
  let parmas = {
    userTel: req.body.phoneNum,
    passWord: req.body.passWord,
  }
  // 查询手机号是否存在
  connection.query(user.queryUserTel(parmas), function (error, results) {
    // 某一条记录的id
    let id = results[0].id
    let pwd = results[0].pwd
    // 修改数据库密码
    connection.query(`update user set pwd= replace(pwd,${pwd},${parmas.passWord}) where id =${id}`, function (err, results) {
      res.send({
        code: 200,
        success: true,
        msg: '修改成功'
      })
    })

  })






})

// 找回密码手机号是否存在
router.post('/api/selectUser', function (req, res, next) {
  let parmas = {
    userTel: req.body.phoneNum,
  }


  connection.query(user.queryUserTel(parmas), function (error, results) {
    if (results.length > 0) {
      res.send({
        code: 200,
        success: true
      })
    } else {
      res.send({
        code: 400,
        success: false,
        msg: '手机号不存在'
      })
    }
  })

})


// 注册接口
router.post('/api/register', function (req, res, next) {

  let parmas = {
    userTel: req.body.phoneNum,
    passWord: req.body.passWord
  }
  //查询用户是否存在
  connection.query(user.queryUserTel(parmas), function (error, results) {
    if (error) throw error;
    //  用户存在
    if (results.length > 0) {
      res.send({
        code: 200,
        data: {
          success: true,
          msg: '用户已注册',
          data: results[0]
        }
      })

    } else {
      //  不存在，新增一条数据
      connection.query(user.register(parmas), function (error, results) {
        res.send({
          code: 200,
          data: {
            success: true,
            msg: '注册成功'

          }
        })

      })
    }
  })


})

// 新增一个用户接口
router.post('/api/login/addUser', function (req, res, next) {

  let parmas = {
    userTel: req.body.phoneNum
  }
  //查询用户是否存在
  connection.query(user.queryUserTel(parmas), function (error, results) {
    if (error) throw error;
    //  用户存在
    if (results.length > 0) {
      res.send({
        code: 200,
        data: {
          success: true,
          msg: '登录成功',
          data: results[0]
        }
      })

    } else {
      //  不存在，新增一条数据
      connection.query(user.inserdata(parmas), function (error, results) {
        connection.query(user.queryUserTel(parmas), function (e, r) {
          res.send({
            code: 200,
            data: {
              success: true,
              msg: '登录成功',
              data: r[0]
            }
          })
        })

      })
    }
  })

})


// 登录短信验证码
router.post('/api/login/Code', function (req, res, next) {
  // 后端接受前端传递过来的值

  let tel = req.body.phoneNum


  // 短信应用SDK AppID
  var appid = 1400187558;  // SDK AppID是1400开头

  // 短信应用SDK AppKey
  var appkey = "dc9dc3391896235ddc2325685047edc7";

  // 需要发送短信的手机号码
  var phoneNumbers = [tel];

  // 短信模板ID，需要在短信应用中申请
  var templateId = 285590;  // NOTE: 这里的模板ID`7839`只是一个示例，真实的模板ID需要在短信控制台中申请

  // 签名
  var smsSign = "茶七网";  // NOTE: 这里的签名只是示例，请使用真实的已申请的签名, 签名参数使用的是`签名内容`，而不是`签名ID`

  // 实例化QcloudSms
  var qcloudsms = QcloudSms(appid, appkey);

  // 设置请求回调处理, 这里只是演示，用户需要自定义相应处理回调
  function callback(err, ress, resData) {
    if (err) {
      console.log("err: ", err);
    } else {
      res.send({
        code: 200,
        data: {
          success: true,
          data: ress.req.body.params[0]
        }
      })
    }
  }

  var ssender = qcloudsms.SmsSingleSender();
  // 这里是手机上发送的验证码
  var params = [Math.floor(Math.random() * (9999 - 1000)) + 1000];
  ssender.sendWithParam(86, phoneNumbers[0], templateId,
    params, smsSign, "", "", callback);  // 签名参数不能为空串



})




// 登录接口
router.post('/api/login', function (req, res, next) {
  // 后端接受前端传递过来的值


  let parmas = {
    userTel: req.body.phoneNum,
    userPwd: req.body.passWord
  }

  // 查询用户手机号是否存在
  connection.query(user.queryUserTel(parmas), function (error, results) {



    if (results.length > 0) {
      // 存在
      connection.query(user.queryUserPwd(parmas), function (error, results) {
        if (results.length > 0) {
          // 手机号密码都对
          res.send({
            code: 200,
            data: {
              success: true,
              msg: '登录成功',
              data: results[0]
            }
          })
        } else {
          // 密码不对
          res.send({
            code: 302,
            data: {
              success: false,
              msg: '密码不正确'
            }
          })

        }
      })

    } else {
      // 不存在
      res.send({
        code: 301,
        data: {
          success: false,
          msg: '手机号不存在'
        }
      })


    }
  })
})


// 分类数据请求
router.get('/api/listInfo', function (req, res, next) {
  res.send({
    code: 1,
    data: [
      // 一级
      {
        id: 0,
        name: '推荐',
        data: [
          {
            // 二级
            id: 0,
            name: '推荐',
            list: [
              // 三级
              {
                id: 0,
                name: '铁观音',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 1,
                name: '金骏眉',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 2,
                name: '武夷岩茶',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 3,
                name: '龙井',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 4,
                name: '紫砂壶',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 5,
                name: '功夫电器',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },

            ]

          },

        ]
      },
      {
        id: 1,
        name: '喜茶',
        data: [
          {
            // 二级
            id: 0,
            name: '喜茶',
            list: [
              // 三级
              {
                id: 0,
                name: '铁观音',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 1,
                name: '金骏眉',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 2,
                name: '武夷岩茶',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 3,
                name: '龙井',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 4,
                name: '紫砂壶',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 5,
                name: '功夫电器',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },

            ]

          },

        ]
      },
      {
        id: 2,
        name: '绿茶',
        data: [
          {
            // 二级
            id: 0,
            name: '绿茶',
            list: [
              // 三级
              {
                id: 0,
                name: '铁观音',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 1,
                name: '金骏眉',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 2,
                name: '武夷岩茶',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 3,
                name: '龙井',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 4,
                name: '紫砂壶',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 5,
                name: '功夫电器',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },

            ]

          },

        ]
      },
      {
        id: 3,
        name: '红茶',
        data: [
          {
            // 二级
            id: 0,
            name: '红茶',
            list: [
              // 三级
              {
                id: 0,
                name: '铁观音',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 1,
                name: '金骏眉',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 2,
                name: '武夷岩茶',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 3,
                name: '龙井',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 4,
                name: '紫砂壶',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 5,
                name: '功夫电器',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },

            ]

          },

        ]
      },
      {
        id: 4,
        name: '乌茶',
        data: [
          {
            // 二级
            id: 0,
            name: '乌茶',
            list: [
              // 三级
              {
                id: 0,
                name: '铁观音',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 1,
                name: '金骏眉',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 2,
                name: '武夷岩茶',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 3,
                name: '龙井',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 4,
                name: '紫砂壶',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 5,
                name: '功夫电器',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },

            ]

          },

        ]
      },
      {
        id: 6,
        name: '普洱',
        data: [
          {
            // 二级
            id: 0,
            name: '普洱',
            list: [
              // 三级
              {
                id: 0,
                name: '铁观音',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 1,
                name: '金骏眉',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 2,
                name: '武夷岩茶',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 3,
                name: '龙井',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 4,
                name: '紫砂壶',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },
              {
                id: 5,
                name: '功夫电器',
                imgUrl: 'https://img.tea7.com/0011478_0.jpeg?x-oss-process=image/resize,w_150'
              },

            ]

          },

        ]
      },

    ]
  });
});


// 搜索商品id
router.get('/api/goods/id', function (req, res, next) {
  // 前端给后端的数据
  let id = req.query.id

  // // sql语句加条件
  connection.query(`select * from recommend where id=${id}`, function (error, results) {
    res.send({
      code: 1,
      data: results[0]

    })

  })

})

// 推荐商品请求
router.get('/api/goods/recommend', function (req, res, next) {
  // 前端给后端的数据
  console.log(req.query);

  // sql语句加条件
  connection.query('select * from recommend ', function (error, results) {
    res.send({
      code: 1,
      data: results

    })

  })

})


// 搜素请求
router.get('/api/goods/shopList', function (req, res, next) {
  // 前端给后端的数据

  let [searchName, orderName] = Object.keys(req.query)
  let [name, order] = Object.values(req.query)

  console.log(searchName, orderName, name, order);

  // sql语句加条件
  connection.query('select * from recommend where name like"%' + name + '%" ', function (error, results) {
    res.send({
      code: 1,
      data: results

    })

  })

})


// 请求首页数据
router.get('/api/index_list/0/data/1', function (req, res, next) {
  res.send({
    code: 0,
    data: {
      tarBar: [
        { label: "推荐" },
        { label: "大红袍" },
        { label: "绿茶" },
        { label: "铁观音" },
        { label: "普洱" },
        { label: "茶具" },
        { label: "花茶" },
      ],
      data: [
        // 这是swiper
        {
          id: 0,
          type: 'swiperList',
          data: [
            { id: 0, imgUrl: 'https://img.tea7.com/0166434_0.jpeg?x-oss-process=image/resize,w_720' },
            { id: 1, imgUrl: 'https://img.tea7.com/0173663_0.jpeg?x-oss-process=image/resize,w_720' },
            { id: 2, imgUrl: 'https://img.tea7.com/0169413_0.jpeg?x-oss-process=image/resize,w_720' },
          ]

        },
        // 这是icons
        {
          id: 1,
          type: 'iconsList',
          data: [
            { img: "./images/icon1.png", text: "自饮茶" },
            { img: "./images/icon1.png", text: "品牌茶" },
            { img: "./images/icon1.png", text: "茶具" },
            { img: "./images/icon1.png", text: "领福利" },
            { img: "./images/icon1.png", text: "官方认证" },
          ]

        },
        // 爆款推荐
        {
          id: 2,
          type: 'recommendList',
          data: [
            {
              img: "./images/hot1.jpeg",
              label: "老铁推荐",
              name: "铁观音2號250g",
              des: "核心产区滋味正 ",
              price: "128",
            },
            {
              img: "./images/hot1.jpeg",
              label: "爆款",
              name: "正山小种3號150g",
              des: "难以忘怀的桂花香 ",
              price: "99",
            },
            {
              img: "./images/hot1.jpeg",
              label: "老铁推荐",
              name: "铁观音2號250g",
              des: "核心产区滋味正 ",
              price: "128",
            },
            {
              img: "./images/hot1.jpeg",
              label: "爆款",
              name: "正山小种3號150g",
              des: "难以忘怀的桂花香 ",
              price: "99",
            },
          ]
        },
        {
          id: 3,
          type: 'like',
          data: [
            {
              id: 1,
              name: "雨前珍稀白茶1号",
              price: "68",
              imgUrl: 'https://img.tea7.com/0170739_0.png?x-oss-process=image/resize,w_300'
            },
            {
              id: 2,
              name: "武夷山灰芽花香金骏眉3号",
              price: "128",
              imgUrl: 'https://img.tea7.com/0012966_0.jpeg?x-oss-process=image/resize,w_300'
            },
            {
              id: 3,
              name: "2022春茶明前龙井飞花",
              price: "128",
              imgUrl: 'https://img.tea7.com/0149490_0.jpeg?x-oss-process=image/resize,w_300'
            },
            {
              id: 4,
              name: "云南凤庆高海拔古树滇红",
              price: "99",
              imgUrl: 'https://img.tea7.com/0014005_0.jpeg?x-oss-process=image/resize,w_300'
            },
            {
              id: 5,
              name: "消青工艺浓香铁观音1号",
              price: "128",
              imgUrl: 'https://img.tea7.com/0130740_0.png?x-oss-process=image/resize,w_300'
            },
            {
              id: 6,
              name: "武夷山高级大红袍2号",
              price: "99",
              imgUrl: 'https://img.tea7.com/0126611_0.jpeg?x-oss-process=image/resize,w_300'
            },
            {
              id: 7,
              name: "漳平水仙兰香1号",
              price: "99",
              imgUrl: 'https://img.tea7.com/0013989_0.jpeg?x-oss-process=image/resize,w_300'
            },
            {
              id: 8,
              name: "安徽雨前黄山毛峰2号",
              price: "68",
              imgUrl: 'https://img.tea7.com/0103362_0.jpeg?x-oss-process=image/resize,w_300'
            },
          ]

        }

      ]
    },



  })
})

// 请求金骏眉数据
router.get('/api/index_list/1/data/1', function (req, res, next) {
  res.send({
    code: 0,
    data: [
      { id: 1, type: 'gb', imgUrl: 'https://imgcon.tea7.com/6363865267776174518533530.jpg' },
      {
        id: 2,
        type: 'like',
        data: [
          {
            name: "武夷山灰芽花香金骏眉3号",
            price: "128",
          },
          {
            name: "武夷山灰芽花香金骏眉3号",
            price: "128",
          },
          {
            name: "武夷山灰芽花香金骏眉3号",
            price: "128",
          },
          {
            name: "武夷山灰芽花香金骏眉3号",
            price: "128",
          },
        ]

      }
    ]

  })
})

module.exports = router;
